<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="robots" content="noindex,nofollow" />
<meta http-equiv="X-UA-Compatible" content="IE=7" />
<TITLE>数据库相关操作-工具-duomicms后台管理</TITLE>
<link href="skin/css/admin.css" rel="stylesheet" type="text/css" />
<script src="skin/js/common.js" type="text/javascript"></script>
<script src="skin/js/main.js" type="text/javascript"></script>
<style type="text/css">
.btn{border:1px solid;border-color:#fff #999 #999 #fff;}
</style>
</head>
<body>
<!--当前导航-->
<script type="text/JavaScript">if(parent.$('admincpnav')) parent.$('admincpnav').innerHTML='后台首页&nbsp;&raquo;&nbsp;工具&nbsp;&raquo;&nbsp;数据高级工具 ';</script>
<div class="container" id="cpcontainer">
<form  method="post" action="?action=result">
<table class="tb">
    <tr class="thead"><td>SQL管理秘书</td></tr>
    <tr><td><textarea name="sql" rows="3" cols="110" value=""></textarea><br /> <input type="submit" class="btn"  value="执行SQL语句">  <input type="reset" value="清除" class="btn"></td></tr>
	<tr>
    <td>
    <p><span style="font-size:16px">操作说明：</span><span style="color:#F00">(请谨慎操作，以免造成数据错误！<a target="_blank" href="http://www.duomicms.net">[?]</a>)</span></p>
	<p style="margin-top:10px">列出所有数据  select * from duomi_data</p>
	<p style="margin-top:10px">列出某一栏目数据  select  *  from duomi_data where tid =(select tid from duomi_type where tname = '频道1')</p>
	<p style="margin-top:10px">删除某一栏目数据  delete  from duomi_data where tid =(select tid from duomi_type where tname = '频道1')</p>
    <p style="margin-top:10px">删除所有数据（id不还原为0）【<span style="color:#F00;">1.</span>delete  from duomi_data】 【<span style="color:#F00;">2.</span> delete  from duomi_playdata】 【<span style="color:#F00;">3.</span>delete  from duomi_content】 （说明：这三个表分别执行一次）</p>
	<p style="margin-top:10px">清空所有数据（id还原为从0开始）【<span style="color:#F00;">1.</span>truncate duomi_data】 【<span style="color:#F00;">2.</span>truncate duomi_playdata】 【<span style="color:#F00;">3.</span>truncate duomi_content】 （说明：这三个表分别执行一次）</p>
	</td></tr>
	</table>
</form></div>
<script type="text/JavaScript">if(parent.$('admincpnav')) parent.$('admincpnav').innerHTML='后台首页&nbsp;&raquo;&nbsp;工具&nbsp;&raquo;&nbsp;SQL高级助手';</script>
<?php viewFoot(); ?>
</body>
</html>